<?php  

//包含连接MySQL的文件  

include("./conn/conn.php");

   
$user = 'admin';
//分页的相关变量  

$pagesize = 5; //每页显示条数  

//获取地址栏中传递的page参数  

if(empty($_GET["page"]))  

{  

    $page = 1;  

    $startrow = 0;  

}else 

{  

    $page = (int)$_GET["page"];  

    $startrow = ($page-1)*$pagesize;  

}  

//构建查询的SQL语句  

$sql = "select*from tb_news where state = 1 and author = '$user'";  

//执行SQL语句  

$result = mysqli_query($link,$sql); 

//总记录数和总页数  

$records = mysqli_num_rows($result); //总记录数  

$pages = ceil($records/$pagesize); //总页数  

   

//构建分页的SQL语句  

$sql = "select*from tb_news where state = 1 and author = '$user' LIMIT $startrow,$pagesize";  

//执行SQL语句  

$result = mysqli_query($link,$sql);  

?>  

<!DOCTYPE html>  

<html>  

<head>  

<meta charset="utf-8">  

<title>新闻管理列表页</title>  

<script type="text/javascript">  

function confirmDel(id)  

{  

    //询问是否要删除  

    if(window.confirm("你确定要删除吗？"))  

    {  

        //如果单击确定按钮，则跳转到del.php页面  

        location.href = "del.php?id="+id;  

    }  

}  

</script>  

<style type="text/css">  

.pagelist{  

    height:40px;  

    line-height:40px;  

}  

.pagelist a{  

    border:1px solid #ccc;  

    background-color:#f0f0f0;  

    padding:3px 10px;  

    margin:0px 3px;  

}  

.pagelist span{padding:3px 10px;}  

</style>  

</head>  

   

<body>  

<div style="padding:5px;"><input type="button" value="添加新闻" onclick="javascript:location.href='add.php'"></div>  

<table width="100%" border="1" bordercolor="#ccc" rules="all" cellpadding="5" align="center">  

    <tr bgColor="#e0e0e0">  

        <th>编号</th>  

        <th>新闻标题</th>  

        <th>作者</th>  

        <th>来源</th>  

        <th>排序</th>  

        <th>点击率</th>  

        <th>发布日期</th>  

        <th>操作选项</th>  

    </tr>  

    <?php  

    while($arr = mysqli_fetch_row($result)){  

    ?>  

    <tr align="center">  

        <td><?php echo $arr['no']?></td>  

        <td align="left"><a target="_blank" href="content.php?id=<?php echo $arr['no']?>"><?php echo $arr['title']?></a></td>  

        <td><?php echo $arr['author']?></td>  

        <td><?php echo $arr['title']?></td>  

        <td><?php echo $arr['title']?></td>  

        <td><?php echo $arr['title']?></td>  

        <td><?php echo date("Y-m-d H:i",$arr['title'])?></td>  

        <td>  

            <a href="edit.php?id=<?php echo $arr['id']?>">修改</a> |   

            <a href="javascript:void(0)" onClick="confirmDel(<?php echo $arr['no']?>)">删除</a>  

        </td>  

    </tr>  

    <?php }?>  

    <tr>  

        <td colspan="8" align="center" class="pagelist">  

            <?php  

                $prev = $page-3;  

                $next = $page+3;  

                if($prev<1){ $prev = 1;}  

                if($next>$pages){$next=$pages;}  

                for($i=$prev;$i<=$next;$i++)  

                {  

                    //如果是当前页，则不加链接  

                    if($i==$page)  

                    {  

                        echo "<span>$i</span>";  

                    }else 

                    {  

                        echo "<a href='fenye3.php?page=$i'>$i</a>";  

                    }  

                }  

               

            ?>  

        </td>  

    </tr>  

</table>  

</body>  

</html>